DELETE FROM [TOUR_ROUTE]
DELETE FROM [SEA_PLACE]
DELETE FROM [PLACE_TIME]
DELETE FROM [PLACE_TOUR]
DELETE FROM [SEA]
DELETE FROM [PERSON_GROUP]
DELETE FROM [PASSPORT]
DELETE FROM [PERSON]
DELETE FROM [HOTEL_PLACE]
DELETE FROM [HOTEL]
DELETE FROM [GROUP]
DELETE FROM [TOUR]
DELETE FROM [COUNTRY_PLACE]
DELETE FROM [PLACE_OF_REST]
DELETE FROM [MAIN_FEATURE]
DELETE FROM [COUNTRY]

INSERT INTO [COUNTRY] ([country]) VALUES ('Австралия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Австрия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Азербайджан');
INSERT INTO [COUNTRY] ([country]) VALUES ('Ангуилья');
INSERT INTO [COUNTRY] ([country]) VALUES ('Аргентина');
INSERT INTO [COUNTRY] ([country]) VALUES ('Армения');
INSERT INTO [COUNTRY] ([country]) VALUES ('Арулько');
INSERT INTO [COUNTRY] ([country]) VALUES ('Беларусь');
INSERT INTO [COUNTRY] ([country]) VALUES ('Белиз');
INSERT INTO [COUNTRY] ([country]) VALUES ('Бельгия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Бермуды');
INSERT INTO [COUNTRY] ([country]) VALUES ('Болгария');
INSERT INTO [COUNTRY] ([country]) VALUES ('Бразилия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Великобритания');
INSERT INTO [COUNTRY] ([country]) VALUES ('Венгрия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Вьетнам');
INSERT INTO [COUNTRY] ([country]) VALUES ('Гаити');
INSERT INTO [COUNTRY] ([country]) VALUES ('Гваделупа');
INSERT INTO [COUNTRY] ([country]) VALUES ('Германия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Голландия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Гондурас');
INSERT INTO [COUNTRY] ([country]) VALUES ('Гонконг');
INSERT INTO [COUNTRY] ([country]) VALUES ('Греция');
INSERT INTO [COUNTRY] ([country]) VALUES ('Грузия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Дания');
INSERT INTO [COUNTRY] ([country]) VALUES ('Доминиканская республика');
INSERT INTO [COUNTRY] ([country]) VALUES ('Египет');
INSERT INTO [COUNTRY] ([country]) VALUES ('Израиль');
INSERT INTO [COUNTRY] ([country]) VALUES ('Индия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Индонезия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Иордания');
INSERT INTO [COUNTRY] ([country]) VALUES ('Ирак');
INSERT INTO [COUNTRY] ([country]) VALUES ('Иран');
INSERT INTO [COUNTRY] ([country]) VALUES ('Ирландия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Испания');
INSERT INTO [COUNTRY] ([country]) VALUES ('Италия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Казахстан');
INSERT INTO [COUNTRY] ([country]) VALUES ('Камерун');
INSERT INTO [COUNTRY] ([country]) VALUES ('Канада');
INSERT INTO [COUNTRY] ([country]) VALUES ('Карибы');
INSERT INTO [COUNTRY] ([country]) VALUES ('Кипр');
INSERT INTO [COUNTRY] ([country]) VALUES ('Киргызстан');
INSERT INTO [COUNTRY] ([country]) VALUES ('Китай');
INSERT INTO [COUNTRY] ([country]) VALUES ('Корея');
INSERT INTO [COUNTRY] ([country]) VALUES ('Коста-Рика');
INSERT INTO [COUNTRY] ([country]) VALUES ('Куба');
INSERT INTO [COUNTRY] ([country]) VALUES ('Кувейт');
INSERT INTO [COUNTRY] ([country]) VALUES ('Латвия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Ливан');
INSERT INTO [COUNTRY] ([country]) VALUES ('Ливия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Литва');
INSERT INTO [COUNTRY] ([country]) VALUES ('Люксембург');
INSERT INTO [COUNTRY] ([country]) VALUES ('Македония');
INSERT INTO [COUNTRY] ([country]) VALUES ('Малайзия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Мальта');
INSERT INTO [COUNTRY] ([country]) VALUES ('Мексика');
INSERT INTO [COUNTRY] ([country]) VALUES ('Мозамбик');
INSERT INTO [COUNTRY] ([country]) VALUES ('Молдова');
INSERT INTO [COUNTRY] ([country]) VALUES ('Монако');
INSERT INTO [COUNTRY] ([country]) VALUES ('Монголия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Морокко');
INSERT INTO [COUNTRY] ([country]) VALUES ('Нидерланды');
INSERT INTO [COUNTRY] ([country]) VALUES ('Новая Зеландия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Норвегия');
INSERT INTO [COUNTRY] ([country]) VALUES ('О.А.Э.');
INSERT INTO [COUNTRY] ([country]) VALUES ('Остров Мэн');
INSERT INTO [COUNTRY] ([country]) VALUES ('Пакистан');
INSERT INTO [COUNTRY] ([country]) VALUES ('Перу');
INSERT INTO [COUNTRY] ([country]) VALUES ('Польша');
INSERT INTO [COUNTRY] ([country]) VALUES ('Португалия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Реюньон');
INSERT INTO [COUNTRY] ([country]) VALUES ('Россия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Румыния');
INSERT INTO [COUNTRY] ([country]) VALUES ('США');
INSERT INTO [COUNTRY] ([country]) VALUES ('Сальвадор');
INSERT INTO [COUNTRY] ([country]) VALUES ('Сингапур');
INSERT INTO [COUNTRY] ([country]) VALUES ('Сирия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Словакия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Словения');
INSERT INTO [COUNTRY] ([country]) VALUES ('Суринам');
INSERT INTO [COUNTRY] ([country]) VALUES ('Таджикистан');
INSERT INTO [COUNTRY] ([country]) VALUES ('Тайвань');
INSERT INTO [COUNTRY] ([country]) VALUES ('Тайланд');
INSERT INTO [COUNTRY] ([country]) VALUES ('Тунис');
INSERT INTO [COUNTRY] ([country]) VALUES ('Туркменистан');
INSERT INTO [COUNTRY] ([country]) VALUES ('Туркмения');
INSERT INTO [COUNTRY] ([country]) VALUES ('Туркс и Кейкос');
INSERT INTO [COUNTRY] ([country]) VALUES ('Турция');
INSERT INTO [COUNTRY] ([country]) VALUES ('Уганда');
INSERT INTO [COUNTRY] ([country]) VALUES ('Узбекистан');
INSERT INTO [COUNTRY] ([country]) VALUES ('Украина');
INSERT INTO [COUNTRY] ([country]) VALUES ('Финляндия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Франция');
INSERT INTO [COUNTRY] ([country]) VALUES ('Хорватия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Чехия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Чили');
INSERT INTO [COUNTRY] ([country]) VALUES ('Швейцария');
INSERT INTO [COUNTRY] ([country]) VALUES ('Швеция');
INSERT INTO [COUNTRY] ([country]) VALUES ('Эквадор');
INSERT INTO [COUNTRY] ([country]) VALUES ('Эстония');
INSERT INTO [COUNTRY] ([country]) VALUES ('ЮАР');
INSERT INTO [COUNTRY] ([country]) VALUES ('Югославия');
INSERT INTO [COUNTRY] ([country]) VALUES ('Южная Корея');
INSERT INTO [COUNTRY] ([country]) VALUES ('Ямайка');
INSERT INTO [COUNTRY] ([country]) VALUES ('Япония');

INSERT INTO [SEA] ([sea]) VALUES ('Адриатическое')
INSERT INTO [SEA] ([sea]) VALUES ('Азовское')
INSERT INTO [SEA] ([sea]) VALUES ('Аки')
INSERT INTO [SEA] ([sea]) VALUES ('Альборан')
INSERT INTO [SEA] ([sea]) VALUES ('Амундсена')
INSERT INTO [SEA] ([sea]) VALUES ('Андаманское')
INSERT INTO [SEA] ([sea]) VALUES ('Аравийское')
INSERT INTO [SEA] ([sea]) VALUES ('Арафурское')
INSERT INTO [SEA] ([sea]) VALUES ('Балеарское')
INSERT INTO [SEA] ([sea]) VALUES ('Бали')
INSERT INTO [SEA] ([sea]) VALUES ('Балтийское')
INSERT INTO [SEA] ([sea]) VALUES ('Банда')
INSERT INTO [SEA] ([sea]) VALUES ('Баренцево')
INSERT INTO [SEA] ([sea]) VALUES ('Баффина')
INSERT INTO [SEA] ([sea]) VALUES ('Беллинсгаузена')
INSERT INTO [SEA] ([sea]) VALUES ('Белое')
INSERT INTO [SEA] ([sea]) VALUES ('Бенгальский залив')
INSERT INTO [SEA] ([sea]) VALUES ('Берингово')
INSERT INTO [SEA] ([sea]) VALUES ('Бофорта')
INSERT INTO [SEA] ([sea]) VALUES ('Ванделя')
INSERT INTO [SEA] ([sea]) VALUES ('Ваттовое')
INSERT INTO [SEA] ([sea]) VALUES ('Висаян')
INSERT INTO [SEA] ([sea]) VALUES ('Внутреннее Японское')
INSERT INTO [SEA] ([sea]) VALUES ('Восточно-Китайское')
INSERT INTO [SEA] ([sea]) VALUES ('Восточно-Сибирское')
INSERT INTO [SEA] ([sea]) VALUES ('Гебридское')
INSERT INTO [SEA] ([sea]) VALUES ('Гренландское')
INSERT INTO [SEA] ([sea]) VALUES ('Гудзонов залив')
INSERT INTO [SEA] ([sea]) VALUES ('Густава-Адольфа')
INSERT INTO [SEA] ([sea]) VALUES ('Дейвиса')
INSERT INTO [SEA] ([sea]) VALUES ('Дюрвиля')
INSERT INTO [SEA] ([sea]) VALUES ('Жёлтое')
INSERT INTO [SEA] ([sea]) VALUES ('Икарийское')
INSERT INTO [SEA] ([sea]) VALUES ('Ионическое')
INSERT INTO [SEA] ([sea]) VALUES ('Ирландское')
INSERT INTO [SEA] ([sea]) VALUES ('Ирмингера')
INSERT INTO [SEA] ([sea]) VALUES ('Ируаз')
INSERT INTO [SEA] ([sea]) VALUES ('Камотес')
INSERT INTO [SEA] ([sea]) VALUES ('Карибское')
INSERT INTO [SEA] ([sea]) VALUES ('Карское')
INSERT INTO [SEA] ([sea]) VALUES ('Кельтское')
INSERT INTO [SEA] ([sea]) VALUES ('Кипрское')
INSERT INTO [SEA] ([sea]) VALUES ('Коралловое')
INSERT INTO [SEA] ([sea]) VALUES ('Коро')
INSERT INTO [SEA] ([sea]) VALUES ('Космонавтов')
INSERT INTO [SEA] ([sea]) VALUES ('Красное')
INSERT INTO [SEA] ([sea]) VALUES ('Критское')
INSERT INTO [SEA] ([sea]) VALUES ('Лабрадор')
INSERT INTO [SEA] ([sea]) VALUES ('Лазарева')
INSERT INTO [SEA] ([sea]) VALUES ('Лаккадивское')
INSERT INTO [SEA] ([sea]) VALUES ('Лаптевых')
INSERT INTO [SEA] ([sea]) VALUES ('Левантийское')
INSERT INTO [SEA] ([sea]) VALUES ('Ливийское')
INSERT INTO [SEA] ([sea]) VALUES ('Лигурийское')
INSERT INTO [SEA] ([sea]) VALUES ('Линкольна')
INSERT INTO [SEA] ([sea]) VALUES ('Мексиканский залив')
INSERT INTO [SEA] ([sea]) VALUES ('Минданао')
INSERT INTO [SEA] ([sea]) VALUES ('Миртойское')
INSERT INTO [SEA] ([sea]) VALUES ('Молуккское')
INSERT INTO [SEA] ([sea]) VALUES ('Моусона')
INSERT INTO [SEA] ([sea]) VALUES ('Мраморное')
INSERT INTO [SEA] ([sea]) VALUES ('Новогвинейское')
INSERT INTO [SEA] ([sea]) VALUES ('Норвежское')
INSERT INTO [SEA] ([sea]) VALUES ('Охотское')
INSERT INTO [SEA] ([sea]) VALUES ('Персидский залив')
INSERT INTO [SEA] ([sea]) VALUES ('Печорское')
INSERT INTO [SEA] ([sea]) VALUES ('Рисер-Ларсена')
INSERT INTO [SEA] ([sea]) VALUES ('Росса')
INSERT INTO [SEA] ([sea]) VALUES ('Саву')
INSERT INTO [SEA] ([sea]) VALUES ('Самар')
INSERT INTO [SEA] ([sea]) VALUES ('Саргассово')
INSERT INTO [SEA] ([sea]) VALUES ('Северное')
INSERT INTO [SEA] ([sea]) VALUES ('Селиш')
INSERT INTO [SEA] ([sea]) VALUES ('Серам')
INSERT INTO [SEA] ([sea]) VALUES ('Сибуян')
INSERT INTO [SEA] ([sea]) VALUES ('Скоша')
INSERT INTO [SEA] ([sea]) VALUES ('Содружества')
INSERT INTO [SEA] ([sea]) VALUES ('Соломоново')
INSERT INTO [SEA] ([sea]) VALUES ('Сомова')
INSERT INTO [SEA] ([sea]) VALUES ('Средиземное')
INSERT INTO [SEA] ([sea]) VALUES ('Сулавеси')
INSERT INTO [SEA] ([sea]) VALUES ('Сулу')
INSERT INTO [SEA] ([sea]) VALUES ('Тасманово')
INSERT INTO [SEA] ([sea]) VALUES ('Тиморское')
INSERT INTO [SEA] ([sea]) VALUES ('Тирренское')
INSERT INTO [SEA] ([sea]) VALUES ('Уэдделла')
INSERT INTO [SEA] ([sea]) VALUES ('Фиджи')
INSERT INTO [SEA] ([sea]) VALUES ('Филиппинское')
INSERT INTO [SEA] ([sea]) VALUES ('Флорес')
INSERT INTO [SEA] ([sea]) VALUES ('Хальмахера')
INSERT INTO [SEA] ([sea]) VALUES ('Харимское')
INSERT INTO [SEA] ([sea]) VALUES ('Цзяочжоу')
INSERT INTO [SEA] ([sea]) VALUES ('Чёрное')
INSERT INTO [SEA] ([sea]) VALUES ('Чукотское')
INSERT INTO [SEA] ([sea]) VALUES ('Эгейское')
INSERT INTO [SEA] ([sea]) VALUES ('Южно-Китайское')
INSERT INTO [SEA] ([sea]) VALUES ('Яванское')
INSERT INTO [SEA] ([sea]) VALUES ('Японское')

INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Kos Hotel Junior Suites', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Maritina Hotel', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Alexandra Hotel', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Citi Hotel', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Lydia Hotel', 2)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('RODOS PARK SUITES SPA HOTEL', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Mediterranean Hotel', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Bellevue Suites', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Papa Nero Studios & Apartments', 2)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Maistrali', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('12 Months Luxury Resort', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Ananti City Resort', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Domotel Xenia Volou', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Kydon Hotel', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Akali Hotel', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Palazzo Duca', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Royal Sun', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Starhotels Metropole', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Starhotels Michelangelo Rome', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hassler Roma', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Grand Hotel Plaza', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Aldrovandi Villa Borghese', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Bretagna', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel De La Ville', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('ROCCO FORTE SAVOY', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Ai Reali', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Pesaro Palace', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Luna Hotel Baglioni', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Concordia', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Palazzo Brunaccini', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Palazzo Sitano', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Mediterraneo', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Grand Hotel Wagner', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Preciados', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Catalonia Plaza Mayor', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Rex', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Wellington', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Urban G.L', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Palace GL', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('NH Calderón', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Claris Apartments', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Acta Atrium Palace', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Caballero', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Sis Pins', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('HM GRAN FIESTA', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Soller', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('HF Fenix Lisboa', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Santa Justa', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('VIP Executive Arts Hotel', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Le Méridien Etoile', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel du Collectionneur Arc de Triomphe', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Banke Hôtel', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Four Seasons Hotel George V Paris', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Negresco', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Le Meridien Nice', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Boscolo Exedra Nice', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Cafe Royal Hotel', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Thistle Piccadilly', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Sofitel London St James', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Holiday Inn London Mayfair', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Radisson Blu Edwardian Hampshire Hotel', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Swissôtel Dresden Am Schloss', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('The Westin Bellevue Dresden', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Motel Dresden Am Zwinger', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Meliá Berlin', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Wyndham Grand Berlin Potsdamer Platz', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Grand Hyatt Berlin', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('The Westin Grand Berlin', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Inntel Hotels Amsterdam Centre', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('NH Grand Hotel Krasnapolsky', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Sunrise Grand Select Arabian Beach Resort', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hotel Novotel Sharm El-Sheikh', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Hilton Sharks Bay Resort', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Отель Золотое кольцо', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Новотель Москва Сити', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Интерконтиненталь Москва Тверская', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Отель Арбат', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Парк Инн Полярные Зори', 4)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Мини-отель Dis', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Steigenberger Al Dau Beach Hotel', 5)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Club Hotel Aqua Fun Hurghada', 3)
INSERT INTO [HOTEL] ([hotel], [stars]) VALUES ('Robinson Club Soma Bay', 4)

INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Храм Асклепион')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Древний город Линдос')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Фермопильское ущелье')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Кносский Дворец царя Миноса')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Колизей')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Флорентийский собор Санта Мария дель Фьори')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Площадь Сан-Марко')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Фонтан стыда Пьяцца Претория')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Королевский дворец в Мадриде')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Саграда Фамилия')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Кафедральный собор Святой Марии')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Монастырь Жеронимуш')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Эйфелева башня')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Английская набережная Ниццы')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Биг-Бен')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Дрезденский архитектурный комплекс Цвингер')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Бранденбургские ворота')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Королевский дворец Амстердама')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Большая мечеть в Шарм-эль-Шейхе')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Красная площадь')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Морские прогулки на катерах вдоль побережья Баренцева моря')
INSERT INTO [MAIN_FEATURE] ([main_feature]) VALUES ('Центральная мечеть')

INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (1, 'о.Кос', 'Это один из самых экологически чистых уголков Греции.Насыщенность острова историческими достопримечательностями.Яркая ночная жизнь и бюджетные цены привлекательны для молодежи.Для ночной жизни много клубов и баров, которые работают до поздней ночи.Великолепный пляж Парадайз.Услуги и оборудование для занятий почти любыми водными видами спорта.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (2, 'о.Родос', 'Красивый, солнечный Родос нередко называют «жемчужиной Средиземноморья».По климату Родос считается лучшим среди всех греческих островов.Историческое наследие: древние греки, византийцы, турки, рыцарские ордена.Чистые песчаные пляжи.Византийские церкви с древними фресками.Прекрасно сохранившиеся античные города.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (3, 'Фессалия', 'Этот регион вобрал в себя практически все чудеса, мифы и легенды Греции! Вы бывали на величественном Олимпе - обители богов, на родине аргонавтов, которые искали золотое руно, в Фермопильском ущелье, где сложили головы легендарные 300 спартанцев? Видели монастыри на «парящих скалах», крепости, скиты, равнину, где сражались боги и титаны? Фессалия – земля, по которой ходили сторукие великаны и одноглазые циклопы.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (4, 'о.Крит', 'Интереснейшие руины — в том числе, знаменитый Кносский дворец.Вкуснейшая средиземноморская кухня.Диктейская пещера: место рождения самого Зевса.Чистое прозрачное море, прекрасные песчаные пляжи.Бухта Балос — самый красивый пляж Средиземноморья.Отличные аквапарки: Water City, Аквапарк Limnoupolis, Acqua Plus.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (5, 'Рим', 'Трехтысячелетняя история столицы великой империи.Здесь есть что посмотреть буквально на каждом шагу: Колизей, фонтан Треви, Ватикан, Сикстинская капелла.Прославленная итальянская кухня, самые вкусные в мире тирамису, паста, пицца.Многогранная атмосфера античности, средневековья, эпохи Возрождения.Возможность, не покидая города, отметиться в еще одной стране: Ватикане. Рим – одна из культурных столиц Европы.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (6, 'Флоренция', 'Флоренция удачно сочетает в себе дух великого прошлого (здесь решительно нельзя ступить ни шагу, не попав на какое-нибудь исторически значимое место) и атмосферу живого и динамичного современного города с отличной кухней, шоппингом и кучей возможностей для развлечений.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (7, 'Венеция', 'Нет смысла описывать какими-то общими фразами этот город на воде, построенный на 122 островах, связанных 400 мостами: все, что вы о нем слышали или читали — правда. И гондольеры, и каналы вместо улиц в старом городе, и красивые старые здания, и, увы, явно чрезмерное обилие туристов.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (8, 'Палермо', 'Палермо — город контрастов: одна его улица — в руинах, вторая — блестит яркой мишурой фешенебельных отелей и бутиков с головокружительными ценами. Но тот, кто сможет найти общий язык с его неутихающей энергией, полным несоблюдением правил дорожного движения и всеобщим хаосом, влюбится в него навсегда.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (9, 'Мадрид', 'Мадрид — столица страны и один из самых красивых городов мира, обладающий колоссальным культурным и художественным наследием. Здесь естественным образом сочетаются современные бизнес-центры и средневековая архитектура, лучшие ночные клубы Европы, крупнейшие аутлеты, прекрасные парки и, конечно же, множество музеев. Хорошо развитая система общественного транспорта в Мадриде — предмет особой гордости города.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (10, 'Барселона', 'Столица Каталонии и самый красивый город на побережье — Барселона. Описать все достопримечательности и красоты города нереально — их надо увидеть. Рамбла, Готический квартал, дома Гауди, музеи гениальных Пикассо и Миро, Саграда Фамилия, Монжуик… список можно продолжать практически бесконечно. Неудивительно, что в разгар лета на улицах Барселоны иностранная речь слышится гораздо чаще испанской.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (11, 'о.Майорка', 'Майорка – крупнейший из островов Балеарского архипелага, равно подходящий для пляжного отдыха, скалолазания, дайвинга и виндсерфинга, да и просто наслаждения природой. Здесь мягкий и тёплый климат, поражающие размерами и красотой горные хребты, густые леса и плодородные долины.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (12, 'Лиссабон', 'Харизма старых районов с кривыми улочками и заброшенными домами.Музыка фадо; «португальский блюз», рожденный из атмосферы Лиссабона.Старинные трамвайчики, чьи маршруты лежат среди живописных кварталов.Мыс Кабо да Рока в часе езды от города — самая западная точка континента.Удобное расположение посередине страны: идеально для исследования Португалии.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (13, 'Париж', 'Возможность вдохнуть атмосферу города, воспетого поэтами и художниками всего мира.Эйфелева башня — ну кто не мечтает сфотографироваться на ее фоне?Великолепная французская кухня, которая не оставит никого равнодушным.Загадочная «Мона Лиза» в самом посещаемом музее мира – Лувре.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (14, 'Ницца', 'Ницца является крупным туристическим центром и ведущим курортом Французской Ривьеры (Лазурного берега), прекрасным местом для отдыха на юго-востоке Франции.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (15, 'Лондон', 'Столица Великобритании, город-достопримечательность и оплот английских традиций, Лондон — самое популярное направление британской экскурсионки (и это несмотря на ощутимую дороговизну направления и очевидную скромность большинства отелей). Увидеть королевских гвардейцев и услышать бой Биг-Бена, покормить воронов в Тауэре и обозреть город с «Лондонского глаза» — вот обязательные занятия столичных экскурсантов (как и традиционный «пятничный стаканчик» в до отказа забитых пабах Сохо).')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (16, 'Дрезден', 'Дрезден (Dresden) является столицей федеральной земли Саксония и расположен в 165 км к югу от Берлина, в 129 км к западу от Праги и в 360 км к северу от Мюнхена. Благодаря характерной барочной архитектуре города и его живописному расположению в долине реки Эльба Дрезден прочно закрепил за собой звание «немецкой Флоренции», впервые получив это сравнение в книге историка Иоганна Готфрида Гердера.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (17, 'Берлин', 'Берлинские музеи – просто сокровищница искусств.Это один из лучших европейских городов для шопинга.Удивительно невысокие для Центральной Европы цены.Атмосфера свободы, благодаря которой город облюбовала европейская богема.Наследие города, еще недавно принадлежавшего сразу двум странам.Искусные граффити на останках Берлинской стены.Огромное количество увеселительных заведений.Славная традициями немецкая кухня.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (18, 'Амстердам', 'Все кольцо амстердамских каналов включено в наследие ЮНЕСКО.Уютные домики квартала Джордан.Кофешопы, где можно попробовать удовольствия, запрещенные в других странах.Велосипедные прогулки вдоль красочных улиц и зеленых парков.Удивительные дома-лодки прямо на водах каналов.Расслабленная, дружелюбная атмосфера.Одни из лучших ночных клубов Европейского континента.Множество маленьких рынков, магазинчиков, антикварных лавок.Одно из самых злачных мест Европы: квартал Красных фонарей.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (19, 'Шарм-Эль-Шейх', 'Наиболее развитая туристическая инфраструктура в стране.Огромное разнообразие отелей всевозможной направленности.Для посещения Шарм-эль-Шейха россиянам не обязательно оплачивать визу.Местные коралловые рифы – отличное место для дайвинга и снорклинга.Заповедник Рас-Мохаммед - мечта любого дайвера.Синайские горы и православная святыня - монастырь Святой Екатерины.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (20, 'Москва', 'Москва — город древний и всегда юный, многоликий и при этом цельный. Москва растет и преображается на глазах, оставаясь при этом истинно русской по своему духу. В Москве есть все и для всех, Москва гостеприимна, доброжелательна, готовая дарить и принимать. В Москве начинается Россия.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (21, 'Дальние Зеленцы', 'Спортивно-туристический центр «Дальние Зеленцы» расположен в живописном месте на побережье Баренцева моря рядом с поселком Дальние Зеленцы.Уникальная бухта, спрятанная от ветров четырьмя островами (Безымянный, Кречетов, Жилой и Немецкий), идеально подходит для морских прогулок, рыбалки, дайвинга, для тех, кто влюблен в море и очарован неповторимой северной природой.')
INSERT INTO [PLACE_OF_REST] ([main_feature_id], [place], [description]) VALUES (22, 'Хургада', 'Огромное количество прекрасных отелей.Теплое Красное море с красивыми коралловыми островами.Множество ярких коралловых рифов.Ветер и волны делают Хургаду идеальным местом для серфинга.Насыщенная ночная жизнь.Дворец «Тысяча и одна ночь», построенный в стиле восточного Диснейленда.Знаменитая мечеть Абульхасана Эльшази.Кухня, богатая рыбой и морепродуктами.Из Хургады легко выбраться на экскурсии в Каир и Луксор.')
INSERT INTO [PLACE_OF_REST] ([place], [description]) VALUES ('empty', 'empty');

INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (1, 1)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (2, 1)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (3, 1)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (4, 1)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (5, 1)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (6, 2)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (7, 2)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (8, 2)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (9, 2)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (10, 3)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (11, 3)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (12, 3)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (13, 3)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (14, 4)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (15, 4)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (16, 4)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (17, 4)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (18, 5)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (19, 5)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (20, 5)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (21, 5)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (22, 5)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (23, 6)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (24, 6)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (25, 6)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (26, 7)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (27, 7)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (28, 7)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (29, 7)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (30, 8)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (31, 8)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (32, 8)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (33, 8)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (34, 9)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (35, 9)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (36, 9)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (37, 9)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (38, 9)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (39, 10)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (40, 10)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (41, 10)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (42, 10)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (43, 11)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (44, 11)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (45, 11)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (46, 11)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (47, 12)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (48, 12)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (49, 12)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (50, 13)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (51, 13)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (52, 13)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (53, 13)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (54, 14)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (55, 14)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (56, 14)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (57, 15)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (58, 15)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (59, 15)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (60, 15)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (61, 15)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (62, 16)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (63, 16)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (64, 16)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (65, 17)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (66, 17)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (67, 17)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (68, 17)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (69, 18)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (70, 18)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (71, 19)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (72, 19)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (73, 19)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (74, 20)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (75, 20)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (76, 20)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (77, 20)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (80, 22)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (81, 22)
INSERT INTO [HOTEL_PLACE] ([hotel_id], [place_id]) VALUES (82, 22)

INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (23, 1)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (23, 2)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (23, 3)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (23, 4)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (36, 5)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (36, 6)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (36, 7)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (36, 8)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (35, 9)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (35, 10)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (35, 11)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (70, 12)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (93, 13)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (93, 14)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (14, 15)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (19, 16)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (19, 17)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (20, 18)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (27, 19)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (72, 20)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (72, 21)
INSERT INTO [COUNTRY_PLACE] ([country_id], [place_id]) VALUES (27, 22)

INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (95, 1)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (95, 2)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (80, 2)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (95, 3)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (47, 4)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (34, 4)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (53, 4)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (1, 7)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (85, 8)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (80, 10)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (9, 11)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (54, 14)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (72, 18)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (46, 19)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (13, 21)
INSERT INTO [SEA_PLACE] ([sea_id], [place_id]) VALUES (46, 22)

INSERT INTO [PERSON] ([first_name], [last_name], [middle_name], [phone_number], [second_number], [email], [country_id])
     VALUES ('Иван', 'Иванов', 'Иванович', '89093641337', '84951234567', 'iii@gmail.com', 72)
INSERT INTO [PERSON] ([first_name], [last_name], [middle_name], [phone_number],[country_id])
     VALUES ('Аввакум', 'Кузнецов','Вадимович', '89693641238', 72)
INSERT INTO [PERSON] ([first_name], [last_name], [middle_name], [phone_number], [second_number], [email], [country_id])
     VALUES ('Добрыня', 'Петров', 'Зигмундович', '81045055050', '86343312567', 'dobrinya@rambler.ru', 72)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [second_number], [email], [country_id])
     VALUES ('Aaron', 'Attwood', '123456', '135246', 'AA@gmail.com', 14)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [email], [country_id])
     VALUES ('Bruce', 'Carroll', '823641337', 'carolina@gmail.com', 14)
INSERT INTO [PERSON] ([first_name], [last_name], [email], [country_id])
     VALUES ('Grace', 'Davidson', 'gRaCeDaViDsOn@gmail.com', 14)
INSERT INTO [PERSON] ([first_name], [last_name], [middle_name], [phone_number], [second_number], [email], [country_id])
     VALUES ('Admin', 'Admin', 'Admin', 'xxxxxxxxxx', 'xxxxxxxxxx', 'admin@ispras.ru', 72)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [email], [country_id])
     VALUES ('Megan', 'Murphy', '111333444', 'WOWOWOW@gmail.com', 14)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [email], [country_id])
     VALUES ('Cameron', 'Austin', '113254744', 'Austin1904@gmail.com', 1)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [email], [country_id])
     VALUES ('Cyrus', 'Duncan', '1928144', 'notmiley@gmail.com', 1)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [second_number], [email], [country_id])
     VALUES ('Jennifer', 'Hodges', '1113334554', '4512223', 'jenHODJ@gmail.com', 74)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [second_number], [email], [country_id])
     VALUES ('Nancy', 'Holmes', '199554', '451823', 'sherlock@gmail.com', 74)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [second_number], [email], [country_id])
     VALUES ('Owen', 'Watson', '1828334554', '49023', 'WATWATWAT@gmail.com', 74)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [email], [country_id])
     VALUES ('Eva', 'Green', '45544', 'alwaysnaked@gmail.com', 93)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [email], [country_id])
     VALUES ('Audrey', 'Tautou', '182478144', 'ameli@gmail.com', 93)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [email], [country_id])
     VALUES ('Colin', 'Farrell', '1824144', 'alexander@gmail.com', 34)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [email], [country_id])
     VALUES ('Christopher', 'Nolan', '18478144', 'CantWaitForInterstellar@gmail.com', 14)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [email], [country_id])
     VALUES ('Matthew', 'McConaughey', '184690', 'ezoscar@gmail.com', 74)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [email], [country_id])
     VALUES ('Leonardo', 'DiCaprio', '15578144', 'whereismyoscar@mail.ru', 74)
INSERT INTO [PERSON] ([first_name], [last_name], [phone_number], [email], [country_id])
     VALUES ('Michael', 'Fassbender', '1903144', 'shame@gmail.com', 19)

INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (1, 72, '1244', '442124', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (1, 72, '1534', '43542224', 1)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (2, 72, '1444', '490244', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (2, 72, '1534', '43790024', 1)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (3, 72, '9014', '435124', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (3, 72, '12992', '1248224', 1)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (4, 14, '90552114', '43518924', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (5, 14, '6469014', '20435124', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (6, 14, '9014886', '453324', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (7, 72, '1337', '123456', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (7, 19, '1337', '113581321', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (7, 74, '108', '4815162342', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (8, 14, '12524', '9990244', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (9, 1, '125244', '9242842', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (9, 1, '15585834', '02022224', 1)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (10, 1, '12912944', '44214124', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (10, 1, '1524934', '43200424', 1)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (11, 74, '12250', '40422', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (11, 74, '1534', '412424', 1)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (12, 74, '12949', '10024', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (12, 74, '249924', '4240104', 1)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (13, 74, '18182', '8248', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (13, 74, '1020', '4389024', 1)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (14, 93, '1200502', '98212', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (15, 93, '124250', '99222', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (16, 34, '7659', '4092', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (17, 14, '19088', '18922', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (18, 74, '998182', '848', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (18, 74, '4242', '7824', 1)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (19, 74, '13422', '8122398', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (19, 74, '12392', '43219120', 1)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (20, 72, '9214282', '2928', 0)
INSERT INTO [PASSPORT] ([person_id], [country_id], [serial], [number], [international])
     VALUES (20, 19, '99292182', '2828248', 0)

INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (5, 18, 36)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (9, 37, 35)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (12, 47, 70)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (5, 20, 36)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (10, 37, 35, 80)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (14, 54, 93, 54)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (20, 74, 72)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (1, 4, 23, 95)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (2, 7, 23, 95)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (4, 15, 23, 53)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (21, 78, 72)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (19, 72, 27, 46)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (22, 80, 27, 46)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (5, 22, 36)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (6, 24, 36)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (7, 28, 36)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (13, 53, 93)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (17, 73, 19)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (15, 57, 14)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (18, 70, 20, 72)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (11, 45, 35, 9)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (3, 11, 23)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (1, 1, 23, 95)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (2, 6, 23, 80)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (3, 10, 23, 95)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (8, 31, 36, 85)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (16, 63, 19)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (17, 66, 19)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (19, 73, 27, 46)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (20, 77, 72)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (21, 78, 72)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (3, 12, 23)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (5, 21, 36)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (13, 50, 93)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (14, 56, 93, 54)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (4, 17, 23, 34)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id], [sea_id]) VALUES (7, 28, 36, 1)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (7, 29, 36)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (15, 61, 14)
INSERT INTO [PLACE_TOUR] ([place_id], [hotel_id], [country_id]) VALUES (13, 51, 93)
INSERT INTO [PLACE_TOUR] ([place_id]) SELECT id
										FROM PLACE_OF_REST
										WHERE (place = 'empty')

INSERT INTO [TOUR] ([name]) VALUES ('Столицы Европы')
INSERT INTO [TOUR] ([name]) VALUES ('Богатая Европа')
INSERT INTO [TOUR] ([name]) VALUES ('Москва')
INSERT INTO [TOUR] ([name]) VALUES ('Острова Греции')
INSERT INTO [TOUR] ([name]) VALUES ('Север')
INSERT INTO [TOUR] ([name]) VALUES ('Жаркий Египет')
INSERT INTO [TOUR] ([name]) VALUES ('Тур по Италии')
INSERT INTO [TOUR] ([name]) VALUES ('Франция - Германия')
INSERT INTO [TOUR] ([name]) VALUES ('Северные столицы Европы')
INSERT INTO [TOUR] ([name]) VALUES ('Майорка')
INSERT INTO [TOUR] ([name]) VALUES ('ЭТО - СПАРТА!')
INSERT INTO [TOUR] ([name]) VALUES ('Тур по Средиземному морю')
INSERT INTO [TOUR] ([name]) VALUES ('Cицилия')
INSERT INTO [TOUR] ([name]) VALUES ('Германия')
INSERT INTO [TOUR] ([name]) VALUES ('Шарм-Эль-Шейх')
INSERT INTO [TOUR] ([name]) VALUES ('Снежная Россия')
INSERT INTO [TOUR] ([name]) VALUES ('Исторический тур')
INSERT INTO [TOUR] ([name]) VALUES ('Пляжи Европы')
INSERT INTO [TOUR] ([name]) VALUES ('Отдых в Венеции')
INSERT INTO [TOUR] ([name]) VALUES ('Лондон - Париж')
INSERT INTO [TOUR] ([name]) VALUES ('empty')

INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (1, 1)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (1, 2)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (1, 3)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (2, 4)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (2, 5)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (2, 6)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (3, 7)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (4, 8)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (4, 9)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (4, 10)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (5, 11)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (6, 12)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (6, 13)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (7, 14)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (7, 15)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (7, 16)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (8, 17)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (8, 18)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (9, 19)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (9, 20)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (10, 21)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (11, 22)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (12, 23)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (12, 24)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (12, 25)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (13, 26)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (14, 27)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (14, 28)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (15, 29)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (16, 30)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (16, 31)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (17, 32)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (17, 33)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (17, 34)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (18, 35)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (18, 36)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (18, 37)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (19, 38)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (20, 39)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) VALUES (20, 40)
INSERT INTO [TOUR_ROUTE] ([tour_id], [place_id]) SELECT TOUR.id, PLACE_TOUR.id
													FROM TOUR, PLACE_TOUR
														JOIN PLACE_OF_REST ON (PLACE_TOUR.place_id = PLACE_OF_REST.id)
													WHERE (TOUR.name = 'empty') AND (PLACE_OF_REST.place = 'empty')

set DATEFORMAT dmy

INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (1, '20/10/2011', '02/11/2011', 0, 50000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (2, '05/05/2011', '30/05/2011', 15, 150000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (3, '07/09/2012', '20/09/2012', 0, 100000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (3, '01/05/2011', '07/05/2011', 10, 40000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (4, '01/07/2009', '30/07/2009', 5, 65000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (5, '01/02/2013', '10/02/2013', 10, 10000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (5, '02/12/2013', '12/12/2013', 0, 15000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (6, '08/08/2013', '22/08/2013', 20, 50000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (6, '01/08/2013', '12/08/2013', 20, 40000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (7, '11/09/2010', '12/10/2010', 10, 85000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (8, '11/09/2014', '19/09/2014', 0, 45000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (9, '12/08/2012', '25/08/2012', 0, 75000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (10, '07/07/2007', '20/07/2007', 20, 85000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (11, '12/05/2008', '20/05/2008', 20, 35000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (12, '06/05/2008', '02/06/2008', 5, 115000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (13, '01/08/2012', '10/08/2012', 0, 55000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (14, '05/11/2012', '20/11/2012', 0, 75000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (15, '01/05/2013', '20/05/2013', 0, 70000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (15, '10/06/2011', '23/06/2011', 5, 60000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (15, '12/08/2012', '19/08/2012', 10, 55000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (16, '25/12/2012', '12/01/2013', 10, 50000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (17, '02/08/2011', '22/08/2011', 0, 40000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (18, '04/07/2014', '29/07/2014', 10, 120000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (19, '01/08/2014', '25/08/2014', 0, 90000)
INSERT INTO [GROUP] ([tour_id], [global_start], [global_end], [discount], [price])
     VALUES (20, '04/09/2013', '18/09/2013', 0, 80000)

INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (1, 1, '20/10/2011', '25/10/2011')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (1, 2, '26/10/2011', '29/10/2011')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (1, 3, '30/10/2011', '02/11/2011')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (2, 5, '05/05/2011', '15/05/2011')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (2, 4, '16/05/2011', '25/05/2011')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (2, 6, '26/05/2011', '30/05/2011')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (3, 7, '07/09/2012', '20/09/2012')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (4, 7, '01/05/2011', '07/05/2011')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (5, 8, '01/07/2009', '10/07/2009')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (5, 9, '11/07/2009', '20/09/2009')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (5, 10, '21/07/2009', '30/07/2009')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (6, 11, '01/02/2013', '10/02/2013')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (7, 11, '02/12/2013', '12/12/2013')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (8, 12, '08/08/2013', '15/08/2013')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (8, 13, '15/08/2013', '22/08/2013')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (9, 12, '01/08/2013', '05/08/2013')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (9, 13, '06/08/2013', '12/08/2013')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (10, 14, '11/09/2010', '20/09/2010')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (10, 15, '21/09/2010', '01/10/2010')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (10, 16, '02/10/2010', '12/10/2010')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (11, 17, '11/09/2014', '14/09/2014')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (11, 18, '14/09/2014', '19/09/2014')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (12, 19, '12/08/2012', '19/08/2012')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (12, 20, '20/08/2012', '25/08/2012')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (13, 21, '07/07/2007', '20/07/2007')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (14, 22, '12/05/2008', '20/05/2008')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (15, 24, '06/05/2008', '12/06/2008')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (15, 23, '13/05/2008', '25/06/2008')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (15, 25, '25/05/2008', '02/06/2008')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (16, 26, '01/08/2012', '10/08/2012')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (17, 27, '05/11/2012', '12/11/2012')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (17, 28, '13/11/2012', '20/11/2012')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (18, 29, '01/05/2013', '20/05/2013')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (19, 29, '10/06/2011', '23/06/2011')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (20, 29, '12/08/2012', '19/08/2012')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (21, 30, '25/12/2012', '02/01/2013')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (21, 31, '03/01/2013', '12/01/2013')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (22, 32, '02/08/2011', '06/08/2011')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (22, 33, '07/08/2011', '14/08/2011')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (22, 34, '15/08/2011', '22/08/2011')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (23, 35, '04/07/2014', '10/07/2014')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (23, 36, '11/07/2014', '20/07/2014')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (23, 37, '21/07/2014', '29/07/2014')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (24, 38, '01/08/2014', '25/08/2014')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (25, 39, '04/09/2013', '12/09/2013')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (25, 40, '13/09/2013', '18/09/2013')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (24, 40, '13/09/2015', '18/09/2015')
INSERT INTO [PLACE_TIME] ([group_id], [place_id], [start_date], [end_date])
     VALUES (25, 39, '13/09/2015', '18/09/2015')

INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (1, 1)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (1, 2)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (1, 5)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (1, 6)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (1, 7)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (2, 1)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (2, 2)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (2, 3)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (2, 4)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (2, 5)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (3, 10)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (3, 15)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (3, 12)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (3, 1)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (3, 6)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (4, 4)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (4, 17)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (4, 5)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (4, 8)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (4, 19)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (4, 20)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (4, 16)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (5, 20)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (5, 5)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (5, 4)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (5, 2)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (5, 14)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (5, 12)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (5, 11)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (6, 9)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (6, 10)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (6, 18)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (6, 15)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (7, 1)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (7, 2)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (7, 3)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (8, 15)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (8, 16)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (8, 11)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (9, 7)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (9, 6)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (9, 18)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (9, 12)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (9, 11)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (10, 13)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (10, 10)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (10, 17)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (10, 20)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (11, 15)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (12, 12)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (12, 11)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (12, 4)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (12, 6)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (12, 5)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (13, 17)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (13, 16)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (13, 19)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (13, 20)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (14, 4)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (14, 15)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (15, 14)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (15, 13)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (15, 12)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (15, 11)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (15, 20)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (16, 1)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (16, 9)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (16, 2)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (16, 8)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (16, 7)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (16, 3)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (17, 17)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (17, 5)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (17, 14)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (17, 13)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (17, 20)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (18, 6)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (18, 8)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (18, 9)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (18, 11)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (18, 10)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (18, 12)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (19, 1)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (19, 2)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (19, 3)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (19, 4)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (20, 7)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (20, 9)
INSERT INTO [PERSON_GROUP] ([group_id], [person_id]) VALUES (20, 13)


